﻿CREATE TABLE [dbo].[tblInventory] (
    [InventoryID] INT IDENTITY (1, 1) NOT NULL,
    [LocationID]  INT NOT NULL,
    [Qty]         INT NOT NULL,
    [ProductID]   INT NOT NULL,
	[Lot]	nvarchar(20) null,
	[Location] nvarchar(20) null,
	[CreateDate] smalldatetime null,
	[QtyOrdered] int null,
	[OrderedDate] smalldatetime null,
	[EstDeliveryDate] smalldatetime null
);

